package com.nowcoder.community.dao;

import com.nowcoder.community.entity.LoginTicket;
import org.apache.ibatis.annotations.*;

@Mapper
@Deprecated // 不推荐使用
public interface LoginTicketMapper {
    // 同过注解的形式来写sql语句
    @Insert({
            "insert into login_ticket(user_id,ticket,status,expired) ",
            "values(#{userId},#{ticket},#{status},#{expired})"
    })
    @Options(useGeneratedKeys = true,keyProperty = "id")
    int insertLoginTicket(LoginTicket loginTicket);

    @Select({
            "select id,user_id,ticket,status,expired ",
            "from login_ticket where ticket = #{ticket}"
    })
    LoginTicket selectByTicket(String ticket);

    @Update({
            "update login_ticket set status = #{status} where ticket = #{ticket}"
    })
//    @Update({
//            "<script>",
//            "update login_ticket set status = #{status} where ticket = #{ticket}",
//            "<if test=\"ticket!=null\">",
//            "and 1=1",
//            "</if>",
//            "</script>"
//    })
    int updateStatus(String ticket, int status);


}
